Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TaxGroupRuleID (FK)(PK) | System assigned unique identifier for the TaxGroupRule. | ID_RU_TX_GRP | Identity | integer | TaxRateRule(RU_TX_RT) |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | WorkstationHistory(LE_HST_WS) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | WorkstationHistory(LE_HST_WS) |
TaxRateRuleSequenceNumber (FK)(PK) | A squential number for theTaxRateRule, denoting the order of creation of the rules. | AI_TX_RT_RU | LineNumber | smallint | TaxRateRule(RU_TX_RT) |
TaxCollectedTotalAmount | The total monetary amount of tax collected by WORKSTATION for each REPORTING PERIOD. | CP_TX_CLT_TOT | Money | decimal(16,5) | |
TaxableSaleTotalAmount | The total monetary amount of taxable sales by WORKSTATION for each REPORTING PERIOD. | CP_SLS_TX_TOT | Money | decimal(16,5) | |
TaxExemptSaleTotalAmount | The total monetary amount of tax exempt sales by WORKSTATION for each REPORTING PERIOD. | CP_SLS_TX_EXM_TOT | Money | decimal(16,5) | |
TaxExemptTransactionCount | The total number of tax exempt transactions by WORKSTATION for each REPORTING PERIOD. | QU_TRN_TX_EXM | QuantityTransactionCount | decimal(7,0) | |